import pandas as pd
import xlwt


def input_completed(data, path,wb,ws):
    '''
    :param data: 输入的数据
    :param path: 文件路径
    :param sheel: 表格名
    :return:
    '''
    data1 = {'number': [x + y * 0.1 for x in range(1, 7) for y in range(1, 5)], 'location': range(3, 27)}
    df1 = pd.DataFrame(data1)
    df1.set_index('number', inplace=True)
    step = 0
    for i in data:
        step += 1
        long = len(i)
        for num in range(2, len(i)):
            ws.write(4 + step, df1.loc[i[num][1], 'location'].item()-1, i[num][0])
    wb.save(path)



